package com.sangdaelee.callme.database;

import android.provider.BaseColumns;

public class DBConstants {
	private DBConstants() {}
	
	public static final class contacts implements BaseColumns {
		private contacts() {}
		
		public static final String _TABLENAME = "all_contacts";
		public static final String CONTACT_ID = "contact_id";
		public static final String CONTACT_NUMBER = "contact_number";
		public static final String CONTACT_NAME = "contact_name";
		public static final String CONTACT_IMAGE_ID = "contact_image_path";
		public static final String CONTACT_RECEIVE = "contact_receive";
		public static final String CONTACT_SEND = "contact_send";
		public static final String CONTACT_ISSR = "contact_issr";
		public static final String CATEGORY_NAME = "category_name";
		public static final String CATEGORY_ID = "category_id";
		public static final String SORT_ORDER = "contact_name ASC";
		public static final String _CREATE = "create table "+_TABLENAME+"("+
				_ID+" integer primary key autoincrement, "+
				CONTACT_ID +" integer, "+
				CONTACT_NUMBER+" text, "+
				CONTACT_NAME+" text, "+
				CONTACT_IMAGE_ID+" text, "+
				CONTACT_RECEIVE+" integer, "+
				CONTACT_SEND+" integer, "+
				CONTACT_ISSR+" text, "+
				CATEGORY_NAME+" text, " +
				CATEGORY_ID+" integer);";
	}
	
	public static final class categorys implements BaseColumns {
		private categorys() {}
		
		public static final String _TABLENAME = "category";
		public static final String CATEGORY_ID = "category_id";
		public static final String CATEGORY_NAME = "category_name";
		public static final String CATEGORY_TIME_NAME = "category_time_name";
		public static final String CATEGORY_TIME_START = "category_time_start";
		public static final String CATEGORY_TIME_END = "category_time_end";
		public static final String CATEGORY_ISSR = "category_issr";
		public static final String CATEGORY_PLUS_TIME = "category_plus_time";
		public static final String _CREATE = "create table "+_TABLENAME+"("+
				_ID+" integer primary key autoincrement, "+
				CATEGORY_ID+" text, "+
				CATEGORY_NAME+" text, "+
				CATEGORY_TIME_NAME+" text, "+
				CATEGORY_TIME_START+" integer, "+
				CATEGORY_TIME_END+" integer, "+
				CATEGORY_ISSR+" text, "+
				CATEGORY_PLUS_TIME+" integer);";
	}
	
	public static final class settings implements BaseColumns {
		private settings() {}
		
		public static final String _TABLENAME = "setting";
		public static final String LIST_SORT = "list_sort";
		public static final String SMS_TEXT = "sms_text";
		public static final String INI_TIME_START = "ini_time_start";
		public static final String INI_TIME_END = "ini_time_end";
		public static final String _CREATE = "create table "+_TABLENAME+"("+
				_ID+" integer primary key autoincrement, "+
				LIST_SORT+" text, "+
				SMS_TEXT+" text, "+
				INI_TIME_START+" text, "+
				INI_TIME_END+" text);";
	}
}
